What is the function to find the Current time and date in SQL Server?

Question

Ashutosh Kumar Verma · Answer

SQL CURRENT_TIMESTAMP:
SQL CURRENT_TIMESTAMP function is used to find the current time and date.
Example:
SELECT CURRENT_TIMESTAMP;
Output:
2021-11-19 21:34:48.493
Another function is GETDATE() is also used to find the current time and date.
SELECT GETDATE();
Output:
2021-11-19 21:38:48.547

interview

What is the function to find the Current time and date in SQL Server?

Ashutosh Kumar Verma

Can you answer this question?

1 Answers

Liked By